Skip Headers

Oracle® Database Advanced Replication 10g Release 2 (10.2) Part Number B14226-01 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G H I J L M N O P Q R S T U V W

## A

  accounts
    creating for materialized views, 6.3.3.3
  additive conflict resolution method, 5.2.3.1
  administrative request queue, 2.2.2.4
  administrative requests, 2.2.2.3
    states, 2.2.2.4
      AWAIT_CALLBACK, 2.2.2.4
      DO_CALLBACK, 2.2.2.4
      ERROR, 2.2.2.4
      READY, 2.2.2.4
  aliases
    for columns
      updatable materialized views, 3.1.3.2
  AND condition
    for simple subquery materialized views, 3.1.6.2
  append sequence conflict resolution method, 5.2.4.2
  append site name conflict resolution method, 5.2.4.1
  assignment tables, 4.4.2.1
  asynchronous replication, 1.4.1, 2.2.4.1.1
  average conflict resolution method, 5.2.3.2

## B

  bulk updates, A.2.5
  BYTE character semantics, B.1

## C

  CHAR character semantics, B.1
  character sets
    replication, B
  collections
    materialized views, 3.1.9.4
      restrictions, 3.1.9.4.1
    replication, 2.1.5.3, 3.1.9.4
  column groups, 5.2.1.1
    column objects, 5.2.1.1.3
    nested tables, 5.2.1.1.5
    object tables, 5.2.1.1.4
    shadow, 5.2.1.1.2
  column objects
    column groups, 5.2.1.1.3
    conflict resolution
      compare old values, 5.2.6.2
      send old values, 5.2.6.2
    materialized views
      column subsetting, 3.1.9.2
    replication, 2.1.5, 3.1.9
  column subsetting, 1.4.2.4
    deployment templates, 4.4.1
    materialized views
      column objects, 3.1.9.2
    updatable materialized views
      conflict resolution, 5.1.5.2
  columns
    character semantics, B.1
    column groups, 2.2.3.2, 5.2.1.1
      column objects, 5.2.1.1.3
      ensuring data integrity with multiple, 5.2.1.1.1
      nested tables, 5.2.1.1.5
      object tables, 5.2.1.1.4
      shadow, 5.2.1.1.2
  complete refresh, 1.4.2.5, 3.2.4.1.1
  complex materialized views, 3.1.4.4, 3.1.4.4.1
    value for PCTFREE, 3.2.4.1.1
    value for PCTUSED, 3.2.4.1.1
  conflict resolution, 2.2.7.2
    additive method, 5.2.3.1
    append sequence method, 5.2.4.2
    append site name method, 5.2.4.1
    architecture, 5.2
    average method, 5.2.3.2
    avoiding conflicts, 5.1.6
    column groups, 5.2.1.1
      column objects, 5.2.1.1.3
      data integrity, 5.2.1.1.1
      nested tables, 5.2.1.1.5
      object tables, 5.2.1.1.4
      shadow, 5.2.1.1.2
    column subsetting
      updatable materialized views, 5.1.5.2
    concepts, 5.1
    convergence properties of methods, 5.2.3
    data requirements, 5.1.1
    delete conflicts, 5.1.2.3
    detecting conflicts, 5.1.4
    discard method, 5.2.3.3, 5.2.4.3
    dynamic site ownership, 5.1.6.2
    earliest timestamp method, 5.2.3.4
    error queue, 5.2.1.2
    in synchronous propagation, 2.2.4.2.1
    latest timestamp method, 5.2.2.1
    maximum method, 5.2.3.5
    methods for delete conflicts, 5.2.5
    methods for uniqueness conflicts, 5.2.4
    methods for update conflicts, 5.2.2
    minimum method, 5.2.3.6
    multitier materialized views, 5.1.5.1
    nested tables, 5.1.5.3
    overwrite method, 5.2.2.2
    performance
      compare old values, 5.2.6
      send old values, 5.2.6
    prebuilt methods, 5.1.5
    primary site ownership, 5.1.6.2
    priority groups method, 5.2.3.7
    replication, 1.6, 2.1.4
    site priority method, 5.2.3.8
      as backup, 5.2.2.1, 5.2.3.4
    transaction ordering, 5.1.3
    types of conflicts, 5.1.2
    uniqueness conflicts, 5.1.2.2
    updatable materialized views
      column subsetting, 5.1.5.2
    update conflicts, 5.1.2.1
  conflicts
    avoiding, 5.1.6
    delete, 5.1.2.3
      avoiding, 5.1.6.3.2
    detecting, 2.2.4.2.3, 2.2.7, 5.1.4
      identifying rows, 2.2.7.1, 5.1.4.2
    error queue, 5.2.1.2
    ordering
      avoiding, 5.1.6.3.4
    procedural replication, 1.7.2.1
    uniqueness, 5.1.2.2
      avoiding, 5.1.6.3.1
    update, 5.1.2.1
      avoiding, 5.1.6.3.3
  connection qualifiers, 2.2.1.2.2
    diagnosing problems with, A.1
  constraint violations, A.2.5
  constraints
    deferrable, 3.2.4.3
    referential
      self-referencing, 2.2.1.3.1
  continuous purges
    scheduling, 6.6.2
  continuous pushes
    scheduling, 6.5.2
  Copy Template Wizard, 7.4.5
  CREATE TYPE statement
    OID clause, 2.1.5.1.2, 3.1.9.1.2
  CREATE_MVIEW_REPGROUP procedure, 3.1.3.2
  CREATE_MVIEW_REPOBJECT procedure, 3.1.3.2

## D

  data dictionary
    replication, 1.5.3
  data integrity
    parallel propagation, 2.2.6.1.1
    serial propagation, 2.2.6.1.1
  data propagation
    and dependency maintenance, 2.2.6.1
    asynchronous, 2.2.4.1.1
    synchronous, 2.2.4.1.2
  database links
    connection qualifiers, 2.2.1.2.2
    diagnosing problems with, A.1
    incomplete specifications, A.3.3
    materialized view sites, 6.3.3.4, 6.8.1.5
    replication, 2.2.1.2
    Replication Management tool, 2.2.1.2.1
    scheduled links, 1.4.3.1
  date expressions, 3.2.4.2.1, 4.3.3.2
  DBA_MVIEW_REFRESH_TIMES view, 3.1.10.1
  DBA_REGISTERED_MVIEWS view, 3.1.10.1
  DBA_REPCATLOG view, 2.2.2.3.1
  DBA_TYPE_VERSIONS
    replication, 2.1.5.1, 3.1.9.1
  DBMS_DEFER_SYS package
    SCHEDULE_PUSH procedure, 6.5.1, 6.5.2
  DBMS_MVIEW package, 3.1.10.3
    EXPLAIN_MVIEW procedure, 3.1.7
    REGISTER_MVIEW procedure, 3.1.10.3
  DBMS_REPCAT package, 2.2.2.3.1, 2.2.2.3.1, 2.2.2.4, 3.1.3.2, 6.11.3.1.1
    COMPARE_OLD_VALUES procedure
      conflict resolution, 5.2.6
    CREATE_MVIEW_REPGROUP procedure, 3.1.3.2
    DO_DEFERRED_REPCAT_ADMIN procedure, 2.2.2.3.1, 2.2.2.4
    SEND_OLD_VALUES procedure
      conflict resolution, 5.2.6
  DDL statements
    replication, 1.5.4
      troubleshooting problems, A.2.2
  deadlocks
    resolving
      in synchronous propagation, 2.2.4.2.1
  deferred transaction queues, 1.4.1, 2.2.1.6
    diagnosing problems with, A.3
    purging propagated transactions, 6.6
    pushing, 2.2.1.8.3
    scheduled purge, 6.3.3.6
    scheduled push, 6.3.3.7
  DELAY_SECONDS parameter, 2.2.5.3
  dependencies
    minimizing, 2.2.6.1.3
  dependency
    ordering
      replicated transactions, 2.2.6.1
    tracking
      parallel propagation, 2.2.6.1.1
      row level, 2.2.6.1.2, 6.1.4
  Deployment Template Wizard, 7.4.3
  deployment templates, 1.4.2.8, 4
    adding materialized views to, 4.3.1.1
    after instantiation, 4.3.3
    architecture, 4.3
    column subsetting, 4.4.1
    concepts, 4.2
    data sets, 4.4.3
    DDL statements, 4.3.1.1
    definition storage, 4.3.1
    design, 4.4
    elements, 4.2.1
    general template information, 4.2.1.1
    instantiation, 1.4.2.8.1, 4.2.2
      offline, 4.2.2.2, 4.3.2.4
      online, 4.2.2.1, 4.3.2.3
      options, 4.3.2.5
      process, 4.3.2
      scenarios, 4.2.2.3
      troubleshooting, A.4.2
    local control, 4.5.1
    materialized view groups, 4.3.3.1
    materialized view logs, 4.2.2.3
    materialized view sites, 4.2.1.6
    objects
      definitions, 4.2.1.2, 4.3.1.1
    packaging, 4.2.2
      for offline instantiation, 4.3.2.2
      for online instantiation, 4.3.2.1
      options, 4.3.2.5
      procedures, 4.2.2.3
      process, 4.3.2
    parameters, 4.2.1.3
      security, 4.2.1.4
    preparing materialized view sites for, 6.8
    refresh groups, 4.3.3.2
    row subsetting, 4.4.2
    user authorization, 4.2.1.5
    user-defined types, 4.2.1.2
    WHERE clause, 4.2.1.4
  direct path load
    fast refresh, 3.2.4.1.2
  discard conflict resolution method, 5.2.3.3, 5.2.4.3
  distributed schema management, 1.5.4
  distributed transactions
    problems with, A.3.2
  DML statements
    replication
      troubleshooting problems, A.2.3
  DO_DEFERRED_REPCAT_ADMIN procedure, 2.2.2.3.1, 2.2.2.3.1, 2.2.2.4
  domain indexes
    replication, 2.2.1.3.2
  dynamic sites
    ownership, 5.1.6.2

## E

  earliest timestamp conflict resolution method, 5.2.3.4
  errors
    error queues, 2.2.1.8.2
      conflicts, 5.2.1.2
  EXISTS condition
    materialized views with subqueries, 3.1.6.2
  EXPLAIN_MVIEW procedure, 3.1.7

## F

  failover sites
    implementing using FAILOVER option, 6.11.3
  fast refresh, 1.4.2.5, 3.2.4.1.2
    avoiding problems, 6.3.6
    determining possibility of, 3.1.7
    direct path load, 3.2.4.1.2
    multitier materialized views, 3.2.4.1.2
  filter columns, 6.3.4.1
  force refresh, 1.4.2.5, 3.2.4.1.3
  foreign keys
    replicated tables, 6.1.2
  function-based indexes
    replication, 2.2.1.3.1
  functions
    replicating, 2.2.1.3.4

## G

  GLOBAL_NAMES initialization parameter, 6.2
  group owner
    materialized view groups, 3.2.3.1.1

## H

  horizontal partitioning. See row subsetting

## I

  Import
    materialized view logs, 3.2.1.3.2
    replication check, 6.11.3.1.1
  indexes
    materialized view sites, 3.2.2.1
    on foreign keys, 6.1.2
    replication, 2.2.1.3.2
  indextypes
    replication, 2.2.1.3.8
  initialization parameters
    editing, 6.3.3.8
    GLOBAL_NAMES, 6.2
    JOB_QUEUE_PROCESSES, 2.2.2.3.1, 6.2
    NLS_LENGTH_SEMANTICS, B.1
    OPEN_LINKS, 2.2.1.2.2, 6.2
    PARALLEL_MAX_SERVERS, 2.2.5.1, 6.2
    PARALLEL_MIN_SERVERS, 2.2.5.1, 6.2
    PROCESSES, 6.2
    replication, 6.2
    REPLICATION_DEPENDENCY_TRACKING, 6.2
    SGA_TARGET, 6.2
    SHARED_POOL_SIZE, 6.2
  INIT.ORA parameters. See initialization parameters
  instantiation
    deployment templates, 1.4.2.8.1, 4.2.2
  interoperability
    replication, 6.4

## J

  job queue processes
    replication, 6.3.3.8
  job queues, 2.2.1.8.3
  JOB_QUEUE_PROCESSES initialization parameter, 2.2.2.3.1, 6.2, 6.3.3.8
  jobs
    checking for scheduled links, A.3.1
    replication, 2.2.2.3.1

## L

  latest timestamp
    conflict resolution method, 5.2.2.1
  length semantics
    replication, B.1
  levels
    multitier materialized views, 3.1.8

## M

  many to many subqueries
    materialized views, 3.1.6.1.3
  many to one subqueries
    materialized views, 3.1.6.1.1
  mass deployment, 3.1.2.2, 4.1
  master definition site, 1.3.3, 2.1.1.3.1
  master groups, 1.3.3, 2.2.3.1
  master materialized view sites, 3.2.1
  master materialized views, 1.4.2, 3.1.8, 3.2.1.1
    materialized view logs, 3.2.1.3
  master sites, 1.3.3
    adding
      circular dependencies, 2.2.1.3.1
      self-referential constraints, 2.2.1.3.1
    advantages of, 6.3.1
    bulk updates, A.2.5
    compared with materialized view sites, 6.3
    constraints
      violations, A.2.5
    DDL changes not propagated, A.2.2
    diagnosing problems with, A.2
    DML changes not propagated, A.2.3
    internal triggers, 3.2.1.2
    length semantics, B.2
      precreated tables, B.2.2
    materialized view registration, 3.1.10
    materialized views, 3.2.1
    replicated objects not created at new, A.2.1
    replication, 2.2.1
    roles, 2.2.1.1
    scheduled links for
      guidelines, 6.5
    scheduled purges for, 6.3.3.6
      guidelines, 6.6
    users, 2.2.1.1
  master tables
    materialized view logs, 3.2.1.3
    materialized views, 3.2.1.1
    redefining online, 3.2.1.3
    reorganizing, 3.2.1.3
  Materialized View Group Wizard, 7.4.2
  materialized view groups, 1.3.3, 3.1.8.2.2, 3.2.3.1
    deployment templates, 4.3.3.1
    group owner, 3.2.3.1.1
    ownership, 3.1.8.2.2
    updatable materialized views, 3.2.3.1
  materialized view logs, 1.4.2.7, 3.2.1.3
    adding columns to, 6.3.4.1
    column logging, 3.1.6.2
      many to many subqueries, 3.1.6.2
      many to one subqueries, 3.1.6.2
      ON PREBUILT TABLE clause, 3.1.6.2
      one to many subqueries, 3.1.6.2
    combination, 3.2.1.3
    creating, 6.3.4
    deployment templates, 4.2.2.3
    filter columns, 6.3.4.1
    Import, 3.2.1.3.2
    join columns, 6.3.4.1
    logging columns, 6.3.4.1
    object ID, 3.2.1.3
    object tables, 3.2.1.3.1
    primary key, 3.2.1.3
    privileges required to create, 6.3.4
    REFs, 3.1.9.5.3
    ROWID, 3.2.1.3
    trigger, 3.2.1.2
    troubleshooting, A.4.3.5
    underlying table for, 3.2.1.3
  materialized view sites, 1.3.3
    adding
      avoiding problems, 6.3.6
    advantages of, 6.3.2
    compared with master sites, 6.3
    database links, 6.3.3.4, 6.8.1.5
    database version, 6.8.1.2
    deferred transaction queues
      scheduled push, 6.3.3.7
    deployment templates, 4.2.1.6
    length semantics, B.3
      prebuilt container tables, B.3.1
    local creation, 4.5
    network connectivity, 6.8.1.1
    preparing for deployment templates, 6.8
    rollback segments, 6.8.1.7
    schedule purge
      guidelines, 6.6
    scheduled links for
      guidelines, 6.5
    schemas, 6.8.1.4
    setup, 6.8.1.3
  materialized views, 1.4.2, 3
    architecture, 3.2
    BUILD DEFERRED
      troubleshooting, A.4.4
    capabilities, 3.1.7
    collection columns
      restrictions, 3.1.9.4.1
    column objects
      column subsetting, 3.1.9.2
    column subsetting, 1.4.2.4
      column objects, 3.1.9.2
    complex, 3.1.4.4, 3.1.4.4.1
      value for PCTFREE, 3.2.4.1.1
      value for PCTUSED, 3.2.4.1.1
    concepts, 3.1
    constraints
      deferrable, 3.2.4.3
    creating, 6.3.5
    creating schemas for, 6.3.3.3
    creator, 3.1.5
    data subsetting, 3.1.2.3, 3.1.6
    deployment templates, 1.4.2.8, 4
      user-defined types, 4.2.1.2
    disconnected computing, 3.1.2.4
    index, 3.2.2.1
    length semantics, B.3
      prebuilt container tables, B.3.1
    local control, 4.5.1
    mass deployment, 3.1.2.2
    master materialized view sites, 3.2.1
    master materialized views, 3.2.1.1
    master sites, 3.2.1
    master tables, 3.2.1.1
    materialized view groups, 3.2.3.1
    materialized view logs, 1.4.2.7, 3.2.1.3
    multitier, 1.4.2, 3.1.8, 3.1.8.2.2
      conflict resolution, 5.1.5.1
      fast refresh, 3.2.4.1.2
      levels, 3.1.8
      master materialized views, 3.1.8
      restrictions, 3.1.8.2
    nested tables
      restrictions, 3.1.9.4.1
    network loads, 3.1.2.1
    object materialized views, 3.1.9.3.1
      OID preservation, 3.1.9.3.3
    object tables, 3.1.9.3
    owner, 3.1.5
    Partition Change Tracking (PCT), 3.2.4.1.2
    preparing for, 6.3.3
    primary key, 3.1.4.1, 3.1.6.2
    privileges, 3.1.5, 6.3.3.5
    read-only, 1.4.2.1, 3.1.3.1
      registration, 3.1.10.3
      unregistering, 3.1.10.3
    refresh groups, 1.4.2.6, 3.2.3.2
      size, 3.2.3.3
    refresher, 3.1.5
    refreshing, 1.4.2.5, 3.2.4
      complete, 3.2.4.1.1
      failures, A.4.3.2
      fast, 3.1.7, 3.2.4.1.2
      force, 3.2.4.1.3
      initiating, 3.2.4.2
      interval, 3.2.4.2.1
      on-demand, 3.2.4.2.2
      querying for last refresh time, 3.1.10.1
      retries, A.4.3.2
      troubleshooting, A.4.3, A.4.3.4
    REFs, 3.1.9.5
      logging, 3.1.9.5.3
      scoped, 3.1.9.5.1
      unscoped, 3.1.9.5.2
      WITH ROWID clause, 3.1.9.5.4
    registration, 3.1.10
    reorganizing, 3.2.1.3
    row subsetting, 1.4.2.4, 3.1.6
    rowid, 3.1.4.3
    simple, 3.1.4.4.1
    simple subquery
      AND condition, 3.1.6.2
    subqueries, 3.1.6.1
      column logging, 3.1.6.2
      EXISTS condition, 3.1.6.2
      joins, 3.1.6.2
      many to many, 3.1.6.1.3
      many to one, 3.1.6.1.1
      one to many, 3.1.6.1.2
      OR condition, 3.1.6.2
      primary key materialized views, 3.1.6.2
      restrictions, 3.1.6.2, 3.1.6.2
    trace file, A.4.3.2
    troubleshooting, A.4
    types of, 3.1.4
    unions with subqueries, 3.1.6.1.4
      restrictions, 3.1.6.3
    updatable, 1.4.2.2, 3.1.3.2
      column aliases, 3.1.3.2
      DELETE CASCADE constraint, 3.1.3.2, 3.2.4.3
      length semantics, B.3.2
      materialized view groups, 3.2.3.1
    updatable materialized view logs, 3.2.2.2
      trigger for, 3.2.2.3
    user-define, 3.1.9
    user-defined datatypes
      ON COMMIT REFRESH clause, 3.1.9
    uses for, 3.1.2
    varrays
      r, 3.1.9.4.1
    writeable, 3.1.3.3
  maximum conflict resolution method, 5.2.3.5
  minimum communication, 2.2.5.2
  minimum conflict resolution method, 5.2.3.6
  multimaster replication, 1.4.1, 2
    architecture, 2.2
    asynchronous, 2.1.3, 2.1.3.1
    concepts, 2.1
    disconnected materialized views, 2.1.2.3
    failover, 2.1.2.1
    load balancing, 2.1.2.2
    synchronous, 2.1.3, 2.1.3.2
    transaction propagation protection, 2.2.6
    uses for, 2.1.2
  multitier materialized views, 1.4.2, 3.1.8
    conflict resolution, 5.1.5.1
    fast refresh, 3.2.4.1.2
    levels, 3.1.8
    master materialized views, 3.1.8
      restrictions, 3.1.8.2.1
    materialized view groups
      ownership, 3.1.8.2.2
    restrictions, 3.1.8.2

## N

  NCHAR datatype
    Unicode, B.5
      interoperability, B.5
  NCLOB datatype
    length semantics, B.5.1
  nested tables
    column groups, 5.2.1.1.5
    conflict resolution, 5.1.5.3
    materialized views, 3.1.9.4
      restrictions, 3.1.9.4.1
    replication, 2.1.5.3, 3.1.9.4
  network
    FAILOVER option, 6.11.3
  NLS_LENGTH_SEMANTICS initialization parameter, B.1
  NOROWDEPENDENCIES clause, 2.2.6.1.2
  NVARCHAR datatype
    Unicode, B.5
      interoperability, B.5
  n-way replication. See multimaster replication

## O

  object identifiers
    agreement for replication, 2.1.5.1, 3.1.9.1
  object materialized views, 3.1.9.3.1
    OID preservation, 3.1.9.3.3
  object tables
    column groups, 5.2.1.1.4
    materialized view logs, 3.2.1.3.1
    materialized views, 3.1.9.3
    replication, 2.1.5.2
  object-relational model
    replication, 2.1.5, 3.1.9
  objects
    replicated
      re-creating, A.2.6
  OF object_type clause
    object materialized views, 3.1.9.3.1
  OID clause
    CREATE TYPE statement, 2.1.5.1.2, 3.1.9.1.2
  ON COMMIT REFRESH clause
    of CREATE MATERIALIZED VIEW, 3.1.9
  ON PREBUILT TABLE clause, 3.1.6.2
    length semantics, B.3.1
  one to many subqueries
    materialized views, 3.1.6.1.2
  online redefinition of tables, 3.2.1.3
  OPEN_LINKS initialization parameter, 2.2.1.2.2, 6.2
  OR condition
    materialized views with subqueries, 3.1.6.2
  Oracle Data Pump
    Advanced Replication, 1.5.4
  Oracle Enterprise Manager Console
    Oracle Replication Management tool, 7
  Oracle Real Application Clusters
    compared to replication, 2.1.2.4, 6.11.1
  Oracle Replication Management tool, 1.5.1, 7
    first login, 7.2
    interface, 7.3
    Navigator pane, 7.3.1
    right pane, 7.3.2
    Topology tab, 7.3.2.1
    usage scenarios, 7.1
    wizards, 7.4
      Copy Template, 7.4.5
      Deployment Template, 7.4.3
      Materialized View Group, 7.4.2
      Setup, 7.4.1
      Template Script Generation Wizard, 7.4.4
  overwrite conflict resolution method, 5.2.2.2

## P

  packages
    replication, 2.2.1.3.3
  packaging deployment templates, 4.2.2
  parallel propagation, 2.2.5.1
    configuring for replication environments, 2.2.5.1
    dependency
      tracking, 2.2.6.1.1
    implementing, 2.2.5.1.1
    planning for, 6.7
    replication environment, 6.7
    row level SCN, 2.2.6.1.2
    tuning, 2.2.5.1.2
  PARALLEL_MAX_SERVERS initialization parameter, 2.2.5.1, 6.2
  PARALLEL_MIN_SERVERS initialization parameter, 2.2.5.1, 6.2
  parameters
    deployment templates, 4.2.1.3
  PCTFREE parameter
    value for complex materialized views, 3.2.4.1.1
  PCTUSED parameter
    value for complex materialized views, 3.2.4.1.1
  peer-to-peer replication. See multimaster replication
  performance
    replication, 2.2.5
  periodic purges
    scheduling, 6.6.1
  periodic pushes
    scheduling, 6.5.1
  planning
    for replication, 6
  PRIMARY KEY constraints
    materialized views, 3.1.4.1, 3.1.6.2
    replicated tables, 6.1.1
  primary sites
    ownership, 5.1.6.2
  priority groups conflict resolution method, 5.2.3.7
  privileges
    materialized views, 3.1.5, 6.3.3.5
  procedural replication, 1.7.2
    detecting conflicts, 1.7.2.1
    restrictions, 2.2.1.3.3
    wrapper, 1.7.2
  procedures
    replicating, 2.2.1.3.4
  PROCESSES initialization parameter, 6.2
  propagation, 2.2.4
    initiating, 2.2.4.4
    modes, 2.2.4.3
    parallel, 2.2.5.1
      implementing, 2.2.5.1.1
      tuning, 2.2.5.1.2
    security context of propagator, 2.2.4.2
  propagator
    replication, 2.2.1.1.2
  purges
    deferred transaction queue
      scheduling continuous, 6.6.2
      scheduling periodic, 6.6.1
  pushes
    deferred transaction queue
      scheduling continuous, 6.5.2
      scheduling periodic, 6.5.1

## Q

  quiescing, 1.4.1.1, 2.2.2.1
    single master
      reduced, 3.1.3.2

## R

  read-o, 3.1.10.3
  read-only materialized views, 1.4.2.1, 3.1.3.1
    registration
      manual, 3.1.10.3
  receiver
    replication, 2.2.1.1.3
  recovery
    replication environments, 6.11.3.1
  redefining tables
    online
      replication, 3.2.1.3
  referential integrity
    self-referential constraints, 2.2.1.3.1
  refresh
    automatic, 3.2.4.2.1
    complete, 3.2.4.1.1
    failures, A.4.3.2
    fast, 3.2.4.1.2
      determining possibility of, 3.1.7
    force, 3.2.4.1.3
    group, 3.2.4.2.1
    initiating, 3.2.4.2
    interval, 3.2.4.2.1
    manual, 3.2.4.2.2
    materialized views, 1.4.2.5, 3.2.4
    on-demand, 3.2.4.2.2
    retries, A.4.3.2
    rollback segments
      troubleshooting, A.4.4
    scheduling, 3.2.4.2.1
      troubleshooting, A.4.4
    troubleshooting
      ORA-12004 error, A.4.4
      ORA-942 error, A.4.4
    truncating materialized views
      troubleshooting, A.4.4
  refresh groups, 1.3.3, 1.4.2.6, 3.2.3.2
    deployment templates, 4.3.3.2
    size considerations, 3.2.3.3
    troubleshooting, A.4.3
  REFRESH procedure, 3.2.4.2.2
  REFRESH_ALL_MVIEWS procedure, 3.2.4.2.2
  REFRESH_DEPENDENT procedure, 3.2.4.2.2
  REFs
    materialized views, 3.1.9.5
    replication, 2.1.5.4, 3.1.9.5
  REGISTER_MVIEW procedure, 3.1.10.3
  REPCAT_IMPORT_CHECK procedure, 6.11.3.1.1
  replication
    administration, 1.5, 2.2.2
    administrative request queue, 2.2.2.4
    administrative requests, 2.2.2.3
      states, 2.2.2.4
    applications that use, 1.2
    assignment tables, 4.4.2.1
    asynchronous propagation, 1.4.1, 2.2.4.1.1
    availability, 6.11
    character sets, B
    checking imported data, 6.11.3.1.1
    column groups, 2.2.3.2
    column subsetting, 1.4.2.4
    compared to Oracle Real Application Clusters, 2.1.2.4, 6.11.1
    conflict resolution, 1.6, 2.1.4, 2.2.7.2
    conflicts
      detecting, 2.2.7
      procedural replication, 1.7.2.1
    connection qualifiers, 2.2.1.2.2
    creating an environment, 7.5
    data requirements, 5.1.1
    database links, 2.2.1.2
      CONNECT TO clause, 2.2.1.2
      Replication Management tool, 2.2.1.2.1
      USING clause, 2.2.1.2
    DDL statements, 1.5.4
    deferred transaction queues, 2.2.1.8.1
      diagnosing problems with, A.3
    deferred transactions, 1.4.1, 2.2.1.6
    defined, 1.1
    DELAY_SECONDS parameter, 2.2.5.3
    dependencies
      minimizing, 2.2.6.1.3
    dependency tracking, 2.2.6.1.2
    deployment templates, 1.4.2.8, 4
      user-defined types, 4.2.1.2
    distributed schema management, 1.5.4
    error queues, 2.2.1.8.2
    failover, 6.11.3
    filter columns, 6.3.4.1
    flowchart for creating environment, 7.5
    groups, 1.3.2, 2.2.3.1
    hybrid configurations, 1.4.3
    Import check, 6.11.3.1.1
    indextypes, 2.2.1.3.8
    initialization parameters, 6.2
    internal procedures, 2.2.1.7
    internal triggers, 2.2.1.5
    interoperability, 6.4
      NCHAR datatype, B.5
      NVARCHAR datatype, B.5
    introduction, 1.1
    job queue processes, 6.3.3.8
    job queues, 2.2.1.8.3
    jobs, 2.2.2.3.1
    mass deployment, 4.1
    master, 1.4.2
    master definition site, 1.3.3
    master groups, 1.3.3, 2.2.3.1
    master materialized views, 1.4.2
    master sites, 1.3.3, 2.2.1
      advantages, 6.3.1
    materialized view groups, 1.3.3
    materialized view logs, 1.4.2.7
    materialized view sites
      advantages, 6.3.2
    materialized views, 1.4.2, 3
    minimum communication, 2.2.5.2
    modes, 2.2.2.1
    multimaster, 1.4.1, 2
    multitier materialized views, 1.4.2
    objects, 2.2.1.3
    performance, 2.2.5
    planning for, 6
    problems
      troubleshooting, A
    procedural replication, 1.7.2
    procedures
      troubleshooting, A.2.8
    propagation, 2.2.4
    propagator, 2.2.1.1.2
    quiesce, 1.4.1.1, 2.2.2.1
    real-time replication. See synchronous replication
    receiver, 2.2.1.1.3
    refresh, 1.4.2.5
    refresh groups, 1.3.3, 1.4.2.6
    replication administrator, 2.2.1.1.1
    replication management API, 1.5.2
    resuming, 2.2.2.2.2
    row subsetting, 1.4.2.4
    scheduled links, 1.4.3.1
    See Also materialized views
    single master, 2.1.1.2
    sites, 1.3.3
      choosing, 6.3
    survivability, 6.11
    suspending, 2.2.2.2.1
    synchronous, 1.7.1, 2.2.4.1.2
    tables, 6.1
      and DML incompatibility, A.2.4
      dependency tracking, 6.1.4
      DML incompatibility, A.2.4
    transaction propagation protection, 2.2.6
    transactions
      dependency ordering, 2.2.6.1
    triggers
      troubleshooting, A.2.8
    troubleshooting, A
    Unicode, B.5
    unsupported datatypes
      BFILE, 6.1.3
      LONG, 6.1.3
    user-defined datatypes, 2.1.5, 3.1.9
    uses of, 1.1
    virtual private database (VPD), 6.3.3.4
  replication catalog, 1.5.3
    DBA_MVIEW_REFRESH_TIMES, 3.1.10.1
    DBA_REGISTERED_MVIEWS, 3.1.10.1
    DBA_REPCATLOG, 2.2.2.3.1
    incorrect views, A.3.4
    USER_REFRESH, A.4.3.2
    USER_REFRESH_CHILDREN, A.4.3.2
  replication management API, 1.5.2, 2.2.2.3
  Replication Management tool. See Oracle Replication Management tool
  replication objects, 1.3.1, 2.2.1.3.7, 2.2.1.3.7
    at materialized view sites
      problems creating, A.4.1
    functions, 2.2.1.3.4
    indexes, 2.2.1.3.2
      function-based, 2.2.1.3.1
      on foreign keys, 6.1.2
    packages, 2.2.1.3.3
    procedures, 2.2.1.3.4
    re-creating, A.2.6
    sequences, 2.2.1.4
    tables, 2.2.1.3.1, 6.1
      dependency tracking, 6.1.4
      DML incompatibility, A.2.4
      foreign keys, 6.1.2
      primary keys, 6.1.1
      unable to generate support for, A.2.7
    triggers, 2.2.1.3.6
  REPLICATION_DEPENDENCY_TRACKING initialization parameter, 6.2
  restrictions
    procedural replication, 2.2.1.3.3
  rollback segments
    materialized view sites, 6.8.1.7
  row subsetting, 1.4.2.4
    deployment templates, 4.4.2
    materialized views, 3.1.6
  ROWDEPENDENCIES clause, 2.2.6.1.2
    creating tables, 6.1.4
  rowids
    rowid materialized views, 3.1.4.3
  rows
    identifying during conflict detection, 2.2.7.1

## S

  SCHEDULE_PUSH procedure, 6.5.1, 6.5.2
  scheduled links, 1.4.3.1, 6.3.3.7
    continuous pushes, 6.5.2
    guidelines, 6.5
    parallel propagation, 6.7
    periodic pushes, 6.5.1
    serial propagation, 6.7
  scheduled purges
    guidelines, 6.6
    periodic purges, 6.6.1
  schemas
    creating for materialized views, 6.3.3.3
  security
    deployment templates, 4.2.1.4
  SEND_OLD_VALUES procedure, 5.2.6
  sequences
    replication, 2.2.1.4
  Setup Wizard, 7.4.1
  SGA_TARGET initialization parameter, 6.2
  shadow column groups, 5.2.1.1.2
  SHARED_POOL_SIZE initialization parameter, 6.2
  simple materialized views, 3.1.4.4.1
  site priority conflict resolution method, 5.2.3.8
    as a backup method, 5.2.2.1, 5.2.3.4
  snapshots. See materialized views
  store-and-forward replication. See asynchronous replication
  subqueries
    in unions
      materialized views, 3.1.6.1.4
    materialized views, 3.1.6.1, 3.1.6.2
      AND condition, 3.1.6.2
      column logging, 3.1.6.2
      EXISTS condition, 3.1.6.2
      joins, 3.1.6.2
      many to many, 3.1.6.1.3
      many to one, 3.1.6.1.1
      one to many, 3.1.6.1.2
      primary key, 3.1.6.2
      restrictions, 3.1.6.2
  subsetting
    materialized views, 3.1.6
      column objects, 3.1.9.2
  survivability, 6.11
    design considerations, 6.11.2
    implementing, 6.11.3
    Oracle Real Application Clusters and, 6.11.1
  synchronous replication, 1.7.1, 2.2.4.1.2, 2.2.4.1.2
    of destination of transactions, 2.2.4.2.2
  synonyms, 2.2.1.3.7
    replication, 2.2.1.3.7
  system change numbers
    row level, 2.2.6.1.2, 6.1.4

## T

  tables
    length semantics, B.2
    precreated
      length semantics, B.2.2
    problems generating replication support for, A.2.7
    redefining online
      replication, 3.2.1.3
    replicating, 2.2.1.3.1, 6.1
      dependency tracking, 6.1.4
      DML incompatibility, A.2.4
  Template Script Generation Wizard, 7.4.4
  trace files
    materialized views, A.4.3.2
  transactions
    propagation
      protection mechanisms, 2.2.6
  triggers
    for materialized view log, 3.2.1.2
    for updatable materialized view logs, 3.2.2.3
    replicating, 2.2.1.3.6
  troubleshooting
    replication problems, A

## U

  Unicode
    NCHAR datatype, B.5
    NVARCHAR datatype, B.5
    replication, B.5
  unions
    with subqueries
      materialized views, 3.1.6.1.4
      restrictions for materialized views, 3.1.6.3
  UNREGISTER_MVIEW procedure, 3.1.10.3
  updatable, 5.1.5.2
  updatable materialized view logs, 3.2.2.2
    trigger for, 3.2.2.3
  updatable materialized views, 1.4.2.2, 3.1.3.2
    column subsetting, 5.1.5.2
    DELETE CASCADE constraint, 3.1.3.2, 3.2.4.3
    length semantics, B.3.2
    materialized view groups, 3.2.3.1
  us, 3.1.9.2
  USER_REFRESH view, A.4.3.2
  USER_REFRESH_CHILDREN view, A.4.3.2
  user-defined datatypes
    materialized views, 3.1.9
      collections, 3.1.9.4
      object tables, 3.1.9.3
      ON COMMIT REFRESH clause, 3.1.9
      REFs, 3.1.9.5
      type agreement, 3.1.9.1
    replication, 2.1.5, 3.1.9
      collections, 2.1.5.3, 3.1.9.4
      column objects, 2.1.5, 3.1.9
      object tables, 2.1.5.2
      REFs, 2.1.5.4, 3.1.9.5
      type agreement, 2.1.5.1, 3.1.9.1
  USLOG$_, 3.2.2.2

## V

  varrays
    materialized, 3.1.9.4
    materialized views
      restrictions, 3.1.9.4.1
    replication, 2.1.5.3, 3.1.9.4
  vertical partitioning. See column subsetting
  views, 2.2.1.3.7
    replication, 2.2.1.3.7
  virtual private database (VPD)
    Advanced Replication requirements, 6.3.3.4

## W

  WHERE clause
    deployment templates, 4.2.1.4
  WITH ROWID clause
    REFs, 3.1.9.5.4
  wrapper
    procedural replication, 1.7.2
  writeable materialized views, 3.1.3.3